SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002680s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415451 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415451 [ RunTime:0.002347s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342989,994175,542505,637217,47120,717242,1031664,141023,1017614,871503,845023,154914,211315,475918,535685,40481,153005,986072,768259,901082,75720,14539,812302,186642,265449,312618,92166,637878,374284,193428,589629,601712,241335,789096,327241,884509,667293,378522,966703,253308,273406,311781,809502,913196,1035315,80035,37951,137525,68324,81734,935344,701686,615889,99496,1019516,367393,828044,607584,770991,627518) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000544s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]