SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500424 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500424 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012059,1012514,280502,458137,211865,504996,759619,353850,203641,432426,905382,869699,824073,200767,738418,582908,224001,70101,770472,195507,947378,264058,320167,566770,563237,484052,846711,1000400,810608,965020,481822,902429,8848,648538,764147,338798,338193,983244,930524,510676,966233,618643,109767,946376,908456,1036338,937935,443585,764127,300528,366441,795217,427826,931338,846545,438717,1016018,465261,267450,286612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500424 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500424 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]