SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002059s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567083 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567083 [ RunTime:0.001572s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (578410,863694,657268,803836,904021,614388,682130,535036,3433,1028106,715057,353757,711400,54571,255108,411086,744759,642304,98318,879540,605381,759183,1009236,129519,815965,100467,725150,583844,8493,767588,300575,179300,204011,625534,604097,523169,263940,718366,724296,1017039,619129,875901,276804,344599,203196,268440,716582,296806,202959,500795,246419,829333,399778,966549,765276,1041269,749708,443909,70891,230448) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001684s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]