SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 171040 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 171040 [ RunTime:0.002162s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534799,871618,773859,692982,405957,425193,970515,724976,919927,891226,308284,704798,400778,197999,40708,223857,63217,65224,295708,94107,55211,473924,769879,782437,366621,300925,992570,323598,284752,118742,1015237,778890,836890,730028,233803,193319,56287,279895,826068,989114,931196,333881,129467,374530,753172,1018328,993463,699722,31547,976839,491941,584079,552973,215210,401605,567053,224789,652066,602241,829870) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 171040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 171040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]