SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108568 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108568 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (81013,376738,1012234,48237,106083,203807,365103,219360,103341,629831,449023,1023467,131974,871022,351184,184168,192963,664292,739717,866542,823922,546667,633558,631706,619589,410783,295266,524146,309402,990414,593351,100326,208924,915577,390734,166336,744843,867,214840,7194,638072,465011,581013,391749,888454,499695,79541,168772,982422,337802,31715,134997,725060,889861,503434,585922,1017086,581099,153364,168309) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000913s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]