SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474499 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474499 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336767,832540,705027,388602,977878,581871,261165,655646,194328,623955,913968,1371,1014750,429893,324657,700170,395243,1033296,658150,488905,158178,783408,737289,626290,299892,731754,152314,606793,883854,368974,917767,974400,367491,401319,716233,290218,109936,1032368,744883,761674,331183,11817,897009,83399,39013,988752,86297,625451,777225,653386,622348,74732,802952,684091,933484,193658,981326,345637,257608,23674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001297s ]