SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 920860 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 920860 [ RunTime:0.003097s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (682709,915025,738578,902600,48905,1040504,434845,726943,49477,389178,361904,1047798,347046,330315,355039,1026674,912065,898383,2310,654164,504320,211328,274759,384022,681095,346186,166466,636514,505421,769208,415790,228110,718807,173698,238989,453140,871091,61311,299058,612777,906539,645801,8026,688583,726867,154262,205343,59182,807569,964044,491132,260840,518962,278164,51911,557946,1044657,144680,229263,149862) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002720s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 920860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 920860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]