SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421722 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421722 [ RunTime:0.002895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (274601,421665,382397,511918,213351,925220,574405,717580,753025,29371,988761,329714,1043460,880304,762851,337186,954936,763841,843855,312540,669504,120606,460853,254225,786875,740862,886888,130210,74492,385999,718095,18250,472224,690446,8393,382659,230539,503678,55511,354607,381785,475267,623201,470553,416252,850557,17581,1013461,716848,372893,754492,278225,190909,879218,441838,419293,494309,823582,422645,686157) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421722 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421722 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001354s ]