SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150181 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150181 [ RunTime:0.001726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (396232,450902,761962,75116,972898,205555,669056,692301,842048,502347,1033704,718077,462099,266715,205777,484895,671412,655860,139332,233639,119965,112734,687004,904994,244630,9938,786240,149162,842834,938190,451695,586066,448022,813552,828044,523056,723800,915915,309118,21304,617506,634207,909223,707955,95422,61572,616492,274617,270855,42343,463561,574515,885862,354404,154816,810387,349768,543808,452054,561923) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000719s ]