SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508045 LIMIT 1 [ RunTime:0.000544s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508045 [ RunTime:0.001641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280213,180544,637224,564678,67027,517420,408446,882193,737228,204045,100344,17412,367951,554661,11610,101638,895788,496990,134405,3224,1028334,801845,531627,636041,924372,106886,813232,853445,760398,623155,807196,827920,136926,777687,877261,746830,172475,80796,797516,742487,784114,884925,493716,760156,501630,422972,77940,958819,887085,103918,915417,390037,140872,846199,1013419,146507,844581,446261,889311,161231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]