SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200398 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200398 [ RunTime:0.001448s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (418265,567344,170073,769456,299718,1028714,977765,168284,398556,148194,798921,470755,306487,323550,1000788,694524,898743,708661,746254,967036,187207,650151,627981,351463,139428,752458,831027,261501,772427,775389,675609,956252,554645,256615,1040558,608055,669057,59516,416516,75070,210477,164609,768868,737810,437721,124608,600756,60128,327279,787191,85102,30456,160048,100765,86150,571012,931998,137274,834397,485550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]