SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5181 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5181 [ RunTime:0.001583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (226709,759465,815051,95004,1030309,292231,691444,741705,895891,740958,69980,713560,774134,216792,887351,197171,594131,573113,842887,699937,193551,407514,176280,204075,509532,496326,462266,228499,864182,860736,992376,496107,1034127,241926,864092,188647,936284,373591,214111,804617,507932,186290,78932,336278,153279,247574,505964,951890,550149,77792,700888,974064,56023,303933,237311,491213,142853,76451,78617,316459) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001783s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002917s ]