SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542336 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542336 [ RunTime:0.001558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (466525,734137,547499,32027,270821,98260,617017,91004,396647,93825,225202,738768,500431,808622,993186,632103,867620,62652,573190,731414,830104,1022798,701604,1019702,496745,1008993,704490,670796,404114,450464,194258,375462,605563,599265,872517,238238,748103,723849,171251,848064,328555,393255,543691,115460,765185,664411,1014486,209463,885380,1013896,535377,865241,674036,366608,432085,614703,2130,933045,475709,523067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542336 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542336 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]