SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520322 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520322 [ RunTime:0.001602s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021252,955123,193579,88719,213081,320515,1015008,885208,385308,442476,237158,98683,480723,306619,364319,402226,295544,879843,449558,931664,471977,208856,334935,344578,237527,340621,823132,881438,220998,808488,598183,427314,51721,342208,991325,68875,921104,377751,171718,509594,358636,37485,362401,533517,50096,602156,215637,663037,776795,44556,893148,386116,756389,280672,460965,635870,749503,6651,67617,651230) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520322 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520322 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]