SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1007041 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1007041 [ RunTime:0.001546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044460,138510,114401,669004,668747,336636,297621,601301,443661,201517,999073,260986,843152,857003,212495,267348,780931,470813,332569,310133,489047,265979,257102,392182,890381,796816,303986,452773,892460,542444,20460,115682,1615,935106,839323,374964,133384,724233,79732,107284,480119,511541,243963,570125,362653,136794,288240,533676,810336,831478,715676,902542,942022,688582,785153,350105,114108,630673,28147,377938) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1007041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1007041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]