SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004810s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 148028 LIMIT 1 [ RunTime:0.001811s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 148028 [ RunTime:0.004492s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428233,595505,73749,108052,92276,484469,100819,637123,296121,311879,789323,906107,177268,796958,96313,671652,453937,657494,329273,303847,248021,408935,197627,1046721,230888,198796,610385,146841,53036,719028,525207,873410,672412,342678,648650,764327,225502,824756,628225,420294,970096,840671,425353,225315,519731,220572,161343,80652,499930,355438,412699,1046831,36279,906432,883350,829140,233688,576194,922320,536576) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 148028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001655s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 148028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000763s ]