SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438016 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438016 [ RunTime:0.001659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (153364,223542,388111,222226,832427,323637,908289,694398,156752,628708,488202,167508,178422,797283,274346,850367,376869,297414,292636,134150,417386,273595,789601,294706,55119,873563,504893,717214,893443,1041152,643790,1015460,899424,940956,243791,824885,390457,195098,194703,168310,433775,659796,98462,311886,723512,876110,449420,636497,507948,505083,338160,606082,671446,404997,300435,616203,419099,659581,714099,441554) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]