SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001501s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570142 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570142 [ RunTime:0.001537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (93092,88218,358964,42024,94908,214031,834204,199283,804471,467273,1029389,807563,934173,589258,123498,877587,868068,230971,457968,137903,369203,172373,631200,553524,463000,776508,582110,458412,812610,719521,823661,390571,414908,904006,209019,693791,668617,111250,717817,505286,46472,909935,737435,933487,673881,827948,426582,67489,63554,170141,783374,797776,918385,736566,371718,828327,404484,733680,942143,687417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]