SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501960 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501960 [ RunTime:0.002652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499484,67226,446524,1038077,33667,228513,161916,444573,547991,954829,783466,114741,920314,658394,170431,561296,45346,656541,36760,214059,201001,853583,628784,684861,851766,163570,672652,989503,320261,50161,780112,264553,331289,737695,279531,722802,632687,20195,932373,239237,573509,1036280,64269,873574,30698,39416,992597,660476,878457,541125,851066,813675,890282,335621,185763,484267,759730,241719,290919,185461) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501960 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501960 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]