SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515241 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515241 [ RunTime:0.003922s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101127,988415,164980,834136,878317,167477,1047839,864828,813511,854113,205342,1014413,756404,911537,61280,975945,716160,131887,423069,559528,479180,839931,1045461,1026402,575064,710699,335280,766524,89324,164682,584972,764796,343239,428543,397573,346138,133035,644617,620699,592491,711232,872161,448404,1021629,347915,434242,551301,321890,165144,438334,1041253,640833,702902,786307,102003,530315,224550,659649,365578,765443) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]