SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481796 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481796 [ RunTime:0.002355s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417802,413922,920913,992268,41616,479933,270527,474057,347314,383596,889978,936061,154364,649028,92270,1017201,379588,324724,383881,531225,978167,747758,747730,34077,606462,993704,233720,941621,948617,828006,275307,763316,680896,138238,563848,631618,112330,165435,125318,627336,209289,482119,811604,344331,593106,988484,7058,227793,156651,512744,345039,543925,7422,399497,532044,513493,785984,123286,193460,308909) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481796 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481796 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]