SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554571 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554571 [ RunTime:0.002092s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534294,106668,261392,774680,959100,660780,590192,1028255,385704,820987,863375,64370,188822,375085,403365,1017323,667401,150009,241069,973125,851689,58679,641822,812515,670309,5674,478197,111752,427373,521547,533144,452421,108575,510287,426575,795199,342068,943471,1044450,1007548,976864,385343,704974,939764,839087,428474,910669,86658,188920,1046804,895493,43245,1041387,368241,574822,569771,930030,493961,782993,551853) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]