SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 926100 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 926100 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (182468,437871,90764,885826,103713,334976,981447,822864,287312,783955,638285,899131,748766,247166,84817,314604,451597,126634,793408,528099,993083,737452,701034,698689,167243,455975,403515,173568,331034,870317,152257,707161,211588,119125,795702,570080,238154,1039645,225410,139987,170510,300804,445460,171315,1027766,1035274,730314,878736,894178,936454,147459,531837,899701,221623,652648,305534,66651,791686,509570,345427) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 926100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 926100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]