SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198102 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198102 [ RunTime:0.003000s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (566073,198118,944703,4601,413061,1006137,562800,54337,862660,73666,1027427,677049,1042917,1024036,522722,329223,258804,165333,347874,898211,426291,958360,898551,212760,220041,624426,276077,508578,440572,947847,74188,44902,217250,75469,180617,971807,838124,340507,559980,955800,739161,892471,662836,1021871,734042,559037,463305,580849,727523,405788,926801,2347,762928,483663,165816,641145,390335,848969,293107,781883) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002062s ]