SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49400 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49400 [ RunTime:0.001749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (804283,838709,134813,32657,735867,570029,239809,341957,765293,349725,2920,1035282,240626,223680,804160,237151,353606,1025293,625970,227164,526183,405722,950139,1034320,468355,556512,614149,341559,1002790,97682,520900,220403,965115,640274,306556,111221,519730,153435,751947,208462,253997,612403,497682,436153,56772,212251,121348,313889,452943,809143,571007,262391,303615,345934,61021,745518,167331,386652,220864,744703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]