SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 941810 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 941810 [ RunTime:0.003489s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020971,828900,500999,287739,628504,343829,176763,930516,704014,126898,945689,525888,509433,836522,104616,266229,221561,740681,769659,442161,224750,899229,579823,355064,272860,391342,754864,924523,172159,318623,890489,277833,1044570,346573,444056,819719,926105,971773,927892,525780,210490,911657,992156,1023349,951255,664308,884603,944866,888369,482529,657280,376205,766703,492276,549396,350250,457282,160737,885897,528390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 941810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 941810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000793s ]