SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521528 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521528 [ RunTime:0.003067s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (158851,157027,252289,665568,968033,746708,398079,538329,722471,8538,585822,950474,431451,262944,203348,273284,328140,173573,920404,575888,482632,192745,56574,987240,322757,1004901,319299,56905,700406,106716,973297,349392,207385,752993,814211,598931,511604,609472,734325,258552,657166,102245,820013,648008,919375,912636,869826,717146,12429,667594,54432,167841,375548,134977,154528,68883,525355,842406,461659,116746) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]