SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103178 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103178 [ RunTime:0.001519s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (636875,691400,107043,718382,736461,8785,517523,95364,2825,266454,867048,720969,634152,458652,855326,871027,969639,725083,224937,924356,570000,588536,907380,1024657,730491,199462,999081,173446,729179,215217,482193,317032,116346,124700,755823,168810,609145,969615,874822,910808,472639,53252,384025,143991,327300,434717,643522,962123,626507,605340,291679,475540,337314,869983,483809,802679,550873,685284,483938,260314) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]