SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103114 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103114 [ RunTime:0.003077s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (93668,408159,165577,638216,928598,443942,115591,468863,649981,693428,1041057,938195,990837,874790,571539,299857,515351,716930,110989,166126,754056,699480,1032014,954762,1021174,27678,456807,766202,45212,256158,118014,63478,268125,707359,175955,375948,497368,836290,220768,794447,670680,6651,97219,648803,155264,397325,760254,937092,331272,883827,139350,628598,819602,223788,394558,119502,736677,598246,606484,554234) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]