SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 840593 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 840593 [ RunTime:0.002750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (775120,307438,261458,192389,562408,907065,51494,552014,491321,936482,595967,1035118,332037,282414,141329,508834,1028423,907240,1002652,924973,380293,322570,183366,804707,158057,634122,352243,483133,535217,525809,556616,191051,179342,278302,637341,456255,308824,889887,667133,524801,831995,836164,842721,268248,679764,728856,354571,125786,336581,638889,119798,412908,190453,1016717,583098,20826,377818,648911,355971,913168) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 840593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 840593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000399s ]