SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000936s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419383 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419383 [ RunTime:0.002253s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (996782,873975,480098,413902,605344,126305,588281,874874,606576,750652,1022192,231996,9031,401421,785644,850989,555078,110007,558603,771880,835377,789282,563059,401078,137465,75573,798490,508894,799234,700902,515213,619300,242116,227346,509313,658135,225616,165833,600623,650024,5099,995781,779760,72481,477089,748742,979756,303253,503935,540958,715604,1013991,60042,607174,95808,70648,170888,555526,834627,145506) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]