SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319991 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319991 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (700292,516187,990605,744067,1016492,131617,423859,423369,326915,707866,239662,422158,202103,65074,93440,569335,715096,216133,712182,225502,593971,461038,410522,709491,574522,756537,328339,890280,1009161,317746,99066,152851,1008188,699750,568512,483405,481842,795111,201794,953926,98714,366686,314280,837807,75353,322839,374724,225129,655281,11555,366711,42902,645082,649458,297871,961383,467471,626360,620459,43794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000676s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]