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` = 270423 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 270423 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (434387,484940,768497,793086,491008,739999,220426,266000,439806,656064,420072,494123,463497,261673,673291,677308,123071,237505,125346,302557,560643,353030,868713,816507,787965,764274,579832,702979,107102,879114,579398,869403,835875,136774,930357,636646,157383,272015,881932,160789,902278,659627,1044718,562333,662714,853169,871569,990247,214910,855089,577578,480826,997959,378556,617977,907320,960042,357806,782367,603625) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 270423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 270423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]