SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025877 LIMIT 1 [ RunTime:0.001457s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025877 [ RunTime:0.003475s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (604414,591549,1039566,430305,849583,97651,671983,900297,701402,436002,196103,879691,380400,445107,112271,804223,471134,256875,659897,380848,472587,571787,438530,358126,1041184,430753,796303,606890,1027730,957534,489487,396410,638764,286055,971835,104344,416899,1042451,193812,28956,18909,523247,487748,1006406,440977,979645,300320,221656,621490,469264,21411,23855,453185,169815,480979,134035,784843,650714,687394,220801) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025877 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025877 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]