SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 355190 LIMIT 1 [ RunTime:0.004114s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 355190 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (521531,76741,36066,455493,106006,1037564,355975,154953,153314,554414,340755,441115,111843,714158,991087,443685,117505,528689,9566,507323,582818,569720,301407,774802,157562,275024,706915,594985,637339,925818,308112,930071,385134,752415,758242,253650,1003175,414325,442907,783017,366457,995387,409062,452465,744145,182136,451992,890065,154715,870693,240692,811732,583841,581798,693412,1040767,42591,657681,242125,968633) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001778s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 355190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 355190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]