SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101005 LIMIT 1 [ RunTime:0.001260s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101005 [ RunTime:0.003090s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (597805,186205,606034,933959,61447,1026684,739571,747505,476415,210464,176723,278624,624696,602900,465102,560695,884591,839686,658015,545902,527184,338048,135077,380766,608009,635640,1046073,63915,422518,698937,736795,714334,133024,47839,907722,394226,901897,316157,307116,403912,319099,214589,424189,475143,679579,14152,58837,12160,508064,432927,162270,227150,420158,335584,872018,725042,1045845,979559,687874,414956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001723s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]