SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555415 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555415 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24260,421584,477776,716929,272291,337864,1046454,371629,532230,177689,488268,834746,430161,827935,77181,440087,930338,632943,45352,657472,96628,987578,140273,508949,145748,69075,280656,5364,38864,583784,445083,37073,769689,864586,107465,821349,120532,297229,85264,15168,440330,144563,1015616,707150,588047,76427,768941,134580,33477,47953,427774,176849,1024660,106672,955748,224157,220743,742884,565981,347442) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]