SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39003 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39003 [ RunTime:0.001503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519663,44604,213194,53772,603769,861263,999648,716101,191132,758885,822569,292615,950142,970490,861215,906041,249484,949399,355480,834085,560508,559308,881400,200,296788,742869,398960,408530,462405,584090,790653,649736,953713,414913,762988,311980,293463,377781,163070,311165,721994,764559,959123,577050,541995,140709,613204,630253,352493,1040203,410403,418521,425150,560553,986639,964994,68025,904667,293309,90548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]