SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508675 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508675 [ RunTime:0.001891s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (779275,484971,648930,573948,231017,280403,918546,428403,934485,789479,372800,448619,699038,791094,779131,446812,8048,620022,341609,759467,992268,157711,756066,358278,858823,571332,186090,94719,548981,829101,379543,777278,28250,410688,963006,656205,398910,403257,899962,598939,208347,430385,571990,736872,456371,891588,303284,51459,35676,735971,1004041,643301,560259,413518,165748,382479,590424,646067,820381,179928) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508675 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508675 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]