SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542520 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542520 [ RunTime:0.002257s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100298,57686,412552,32369,816596,131810,982742,433155,234117,828413,517694,234176,321263,435386,896764,481789,608624,66231,827147,159785,918719,263434,246898,796029,554021,452371,789492,304619,791536,454197,803204,951534,828614,592066,331475,586721,971243,52062,1029737,549256,120172,118032,334828,466444,954936,356689,562556,479023,24995,540420,133626,656980,454602,376176,1027298,918278,1006815,593491,120907,323926) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542520 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542520 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]