SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002360s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526001 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526001 [ RunTime:0.004326s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (959698,192427,142070,909677,23048,84689,1011852,638408,976498,705749,892878,677335,200868,375072,475650,790119,81272,862360,517253,383210,728204,819730,634931,512131,172006,1005392,757104,698841,249353,363832,90155,983750,658721,651288,295644,325548,545707,160655,579095,71822,522283,227892,708799,29082,769410,825323,1024663,496081,408558,180470,770284,806815,155670,772242,741347,436842,411527,166532,112055,177337) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001898s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001177s ]