SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453581 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453581 [ RunTime:0.001532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499871,517098,112173,588018,212901,274251,593807,472630,404775,720488,578736,41875,982979,521113,582838,555004,234232,487172,95458,268239,328431,1047170,621236,745383,39990,392187,413905,7071,713755,635683,607478,350793,765567,921355,110031,770097,872299,55829,55341,961288,712012,931990,789287,133605,203929,210160,1033941,585317,432620,211620,894018,953737,660850,650908,78565,135456,589993,492445,521384,993110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]