SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001504s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532923 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532923 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486720,875524,1027758,533949,956989,381767,742510,331398,329714,222752,872272,469249,76420,80536,346237,422386,459894,924429,234511,218801,1045671,100528,73768,372353,766534,734983,1023651,1036287,286178,80611,793748,823110,362984,7672,175123,592488,447287,240505,619961,224613,623775,335919,880522,145795,452002,282282,357314,44022,831513,219431,514058,446048,497166,1008980,349915,404844,369163,76167,65080,295184) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001353s ]