SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036367 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036367 [ RunTime:0.002950s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (860797,1011067,131980,952416,474333,78407,988389,250218,358720,2292,709917,873575,140551,629025,57630,615845,62356,661164,181545,377999,542160,394791,717146,601450,785690,370098,81523,952714,982391,511349,652429,346760,253048,454146,1039598,332974,713859,853989,135662,355847,519310,998774,1000846,332320,713074,114137,446816,283789,1012252,145587,833499,813101,814234,914189,90307,91969,663407,16004,387959,159263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036367 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036367 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]