SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506544 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506544 [ RunTime:0.002720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (48508,350016,370228,546685,164566,704635,895939,962739,41465,940282,333492,700890,607435,644381,84957,802019,897941,376799,444577,459842,251231,477285,163820,541332,276361,675928,826089,972490,928523,716773,616991,92553,165399,362796,64278,545459,554215,556908,992035,297599,129169,724793,564583,334046,959038,760234,597126,96897,502056,568178,299431,294454,801893,783144,505841,854315,876862,447022,128492,913804) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506544 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506544 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]