SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 443453 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 443453 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575579,793422,369297,403148,761309,128277,1002366,839545,130000,79003,246960,359873,116139,901813,864119,202700,968297,524452,834672,301260,799108,412482,152383,1036624,283305,471102,329276,896611,12285,929134,198870,430076,346308,556312,887449,544841,148472,687854,1031402,807705,559685,620840,453543,725395,737153,935811,470838,966112,992974,217860,850832,354439,945731,839573,809681,277784,71603,1013530,350851,518178) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 443453 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 443453 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]