SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494209 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494209 [ RunTime:0.002072s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420326,219910,655501,389884,300945,16907,946216,281911,361743,447712,563567,143249,755846,683820,80861,759170,238336,883200,535122,81949,305780,693118,385359,40940,1031248,913856,211138,362530,820989,369644,708817,525211,159758,462239,792492,915518,172875,670319,6667,121082,215298,733293,439792,400380,962562,226113,262263,801041,193131,889728,836484,946113,552697,1001004,398030,531443,249114,785767,285117,284426) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]