SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450075 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450075 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499242,952982,875514,29315,551073,679450,366802,267853,30718,362303,615955,132138,840634,94075,951373,894502,637863,753449,307588,878263,621786,161505,396868,746149,272350,667713,987482,1041314,401385,975255,476412,325164,376617,741892,282573,1021299,813060,60252,156111,147567,715309,772601,868324,618234,8677,789120,173990,769988,19843,96279,247374,866193,1024474,290002,982182,298886,975834,247057,565713,352410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]