SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003981s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505060 LIMIT 1 [ RunTime:0.000963s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505060 [ RunTime:0.002765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (326747,890170,95895,202111,148748,55552,344710,185717,296797,103167,314720,741391,980432,668913,625224,713026,438759,175445,899544,875602,777122,890889,953998,520342,336080,939391,271124,188617,692881,765962,194146,125594,291177,5158,574366,217224,1011061,387196,854807,848173,324562,621174,406922,596843,797839,344265,764272,480386,267249,524293,81271,66338,534615,785464,1034757,736979,453068,834728,69045,816814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]