SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342191 LIMIT 1 [ RunTime:0.002162s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342191 [ RunTime:0.001741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108948,571699,296272,109146,249757,1026830,232133,1025516,953685,750325,272228,704253,288741,879939,299344,414111,860327,925063,422821,986006,679243,496226,230577,216043,79566,659366,980401,235311,92580,509086,426328,117503,1041419,742870,802982,126768,1000232,378166,866879,575781,127520,295335,590868,369836,533016,139019,798143,717129,1017566,779303,884555,755370,64489,607548,387344,971912,403988,358414,20811,431561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001681s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000602s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]