SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200696 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200696 [ RunTime:0.004190s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (593316,914955,964559,981094,449388,69178,51284,206956,314302,765004,743954,297805,102525,646824,760765,353488,638068,594518,547396,67486,1006167,640624,552288,650486,957501,6926,986203,69894,199581,517022,684553,539533,1005542,458357,1024839,537739,781185,965764,158375,313504,588441,408439,517864,535462,728194,249335,987886,230824,176273,780588,439615,507217,987071,1036278,112508,281616,502283,859084,441099,462624) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001647s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200696 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200696 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]