SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10358 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10358 [ RunTime:0.001824s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (345873,232489,852281,118455,944305,1031824,617671,769587,102321,980074,73034,230087,146091,607411,247368,698159,634743,397463,902504,475933,938943,66866,992483,759833,695855,381408,280534,781092,42301,79067,431709,578769,211206,318417,144206,919824,259933,390174,737783,321074,236706,986301,239269,409855,88679,913922,131243,531129,65747,529154,320696,52840,289790,132602,656258,51691,947708,947457,757577,749038) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10358 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10358 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]