SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198614 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198614 [ RunTime:0.002568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (815785,627130,44291,247851,564204,137630,492996,936896,1043564,226339,626150,655635,1003171,289443,142644,344295,1035053,540928,944629,39896,597413,108979,743416,386296,307509,115630,784436,138008,312411,1004495,681354,910476,284493,401981,988104,955956,530684,126579,856406,1007911,586119,236814,440973,408622,902769,255525,31099,811549,544948,941527,593683,280334,126508,463341,222796,656948,822722,330529,7445,432043) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198614 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198614 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]