SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520820 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520820 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (674673,403859,744179,29684,511778,53908,519902,709281,378668,236548,907552,1015354,719690,38173,901613,579416,541925,990453,968792,1016615,465534,687366,929530,548187,471303,941525,862163,717760,840786,250798,463078,342482,125858,436002,261595,658937,181690,191871,855575,694214,731851,1016532,789399,748571,295635,67700,679793,574173,613019,296962,555817,268201,60518,291745,129865,624027,152092,947326,300134,1037423) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]