SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427991 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427991 [ RunTime:0.002261s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (917813,576415,919209,548950,231012,82313,279059,131270,1720,105787,410504,449865,323960,984759,803098,946742,60564,545847,469665,1002040,764457,180235,561918,579312,108974,172921,226694,490239,362249,313230,973318,615821,557163,703966,355023,590120,720169,245660,303257,81398,572137,313490,967076,595871,433478,968598,253067,887494,104466,897970,896849,708629,95288,13993,608101,440578,245070,847878,652616,883239) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]