SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526289 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526289 [ RunTime:0.002016s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (987792,387673,912465,965430,1006512,414306,91850,118745,1046001,565940,859371,58922,980050,480945,958018,419898,547564,651112,432344,301112,817852,552815,966808,813753,219604,866527,642009,879937,401623,208395,291510,651138,274122,525355,877747,979098,977200,1018539,562096,549570,464058,776342,996087,350322,267359,1006917,226298,269752,88487,165350,651335,256601,51587,134776,457603,207072,462722,323618,856408,956008) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526289 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526289 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]