SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556401 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556401 [ RunTime:0.003497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539047,325836,109969,682161,767332,674872,143953,843894,427955,256716,115272,185740,942912,290597,283745,407105,557780,122818,162963,728046,16775,888391,765543,256998,880212,785504,678409,260149,299888,685932,238417,972977,947674,761614,774980,1025332,247247,227414,364733,205795,401623,499225,27863,227391,519390,862961,547210,826792,113893,576779,378073,626291,300974,269988,390330,838803,1017809,255093,581621,299609) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000694s ]