SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108608 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108608 [ RunTime:0.005046s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (379799,826051,696100,453940,1043537,339193,486609,40802,610672,238788,516712,86004,586684,1021441,984712,752550,364524,153365,150209,695700,402794,952702,842925,252494,881925,483768,69481,888806,814835,750424,341587,922720,899458,467358,796691,600560,579662,73931,755391,487325,594648,183368,803420,134410,1044501,69213,914502,585749,261541,834759,417039,738302,363143,291206,591990,478488,325940,226744,539937,611837) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001891s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108608 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108608 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]