SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002464s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506702 LIMIT 1 [ RunTime:0.000694s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506702 [ RunTime:0.001818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (581279,242891,252357,17518,615934,754817,463870,37838,495928,147030,215248,138744,466977,124717,953067,684025,33836,1043702,498524,145639,292523,438813,941170,167582,304962,118269,281586,121227,1002987,765259,407963,402699,267925,262768,664829,34921,729745,614747,389480,551170,391749,175227,345085,575089,3334,708742,84812,590467,991361,632060,37118,608059,786256,704216,671776,866589,517193,91567,908222,1024708) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506702 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000622s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506702 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]