SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002721s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455310 LIMIT 1 [ RunTime:0.001879s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455310 [ RunTime:0.002768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (432409,660285,240010,316007,466641,869596,643108,942578,422897,736975,308578,261498,708567,380489,101180,70662,330131,988191,566304,1013347,970856,1035090,587326,644920,674234,388573,922514,244039,828643,51740,711773,472902,876654,733391,589829,380624,1044305,484679,321280,235119,769948,151812,826558,604217,889591,196246,519666,944605,661746,188003,976324,600384,421681,1034816,92753,223117,460568,756715,572973,928937) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]