SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681023 LIMIT 1 [ RunTime:0.003219s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681023 [ RunTime:0.007423s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (853711,550234,665622,302868,392861,420585,920010,808932,198860,242498,170666,276902,808292,490762,900771,790025,353019,287079,469270,75884,817359,513742,903628,409354,631227,625883,812535,385359,592829,924840,378591,442965,169194,822384,844713,805459,866549,348398,163238,150286,594939,435057,775478,298710,632828,433529,659730,210134,90173,140748,443882,489609,101987,332532,475581,464431,396559,825515,192499,809462) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000691s ]