SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 56101 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 56101 [ RunTime:0.001420s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (936058,726284,339613,345898,897895,513223,1010693,163812,757349,439751,658856,448307,974996,635559,459574,105742,333477,391012,189343,461524,80093,317495,23786,979355,576268,577847,949561,932390,855545,1010882,804163,482788,362347,616701,493215,900597,38408,249011,505573,290502,641514,998531,89981,774821,159928,193544,982189,1013946,417309,422409,472825,211502,85659,581304,431082,146638,440933,588447,94336,148620) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001610s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 56101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 56101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]