SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412645 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412645 [ RunTime:0.003287s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (876369,768901,145277,254935,855027,795330,911966,576171,388250,251300,696698,346419,294216,658141,196906,767941,234103,12386,74313,3555,1009390,139305,220325,845408,827539,861911,311693,830740,440176,252583,727004,919013,819664,776330,858513,825166,584812,148520,143264,927204,24994,93287,207834,26346,648606,815135,863965,663980,962845,826488,435561,202203,665417,412418,174430,239965,6609,535001,773378,745108) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412645 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412645 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]