SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3100 LIMIT 1 [ RunTime:0.000283s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3100 [ RunTime:0.005789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (760039,596391,4177,612223,64309,273170,180727,247561,810752,212717,37325,932961,616468,608382,993434,760082,764600,1033202,337913,323602,104542,931533,9320,755804,121909,492844,226422,314599,207564,247063,632996,26536,803833,285111,899567,760828,255354,390501,51184,14745,249873,200214,372018,699754,723268,423907,209809,546159,901439,200676,1031946,31114,51626,441247,11742,251970,777568,570803,876704,884486) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]