SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001472s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399640 LIMIT 1 [ RunTime:0.000475s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399640 [ RunTime:0.002690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (46264,934478,798063,393751,125653,466157,1000366,947742,327762,992802,123107,461081,312552,1040936,763613,725354,954087,398575,152032,193181,564838,805146,667902,634183,233067,73823,486033,899970,378063,281417,254202,939886,507959,175056,756615,698833,683970,447988,768189,1021568,823233,491364,783954,630645,912632,139346,127011,535049,75330,124144,17622,93077,346172,213029,928353,573071,776119,667944,79340,42881) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001498s ]