SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802618 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802618 [ RunTime:0.001735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585541,340647,135890,1030281,381005,184922,190712,135707,837911,1042162,237228,36812,610574,275606,670807,154163,794398,926535,562155,844016,198692,433406,963761,72264,271181,253729,863576,870594,251228,420217,34179,253294,358688,646549,283142,489975,449957,518570,583372,748263,474441,529891,373250,608115,675862,288984,474418,934872,676395,724302,1015320,470733,13163,642562,263809,147035,419818,28738,902750,668984) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]