SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001389s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354670 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354670 [ RunTime:0.001491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (979048,243574,572518,205937,287452,710571,1378,196351,55663,382650,160526,504441,646932,529234,757910,321487,93371,295105,17184,833678,604543,31917,676480,516972,494000,919022,868484,929262,138353,618645,374034,526073,215124,199409,792384,385372,777399,906694,344723,41015,326958,96013,522337,142117,656442,340752,471645,532313,293013,205869,210761,577493,176601,482964,1009951,994508,836917,1017238,829293,911580) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354670 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354670 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]