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` = 434211 LIMIT 1 [ RunTime:0.001329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434211 [ RunTime:0.005567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (212588,65442,703482,956759,748645,256605,1043746,537245,564502,244171,440032,230218,443649,967608,659309,180747,157862,911892,952605,741180,559419,220727,523046,59314,876700,793004,918319,965309,328756,294763,801301,688253,229404,941236,1009482,645161,958131,762761,466056,379799,533893,216460,268941,20175,973596,691529,802654,951499,711041,1015432,34535,43041,59657,663921,675322,951760,282161,365432,22969,84915) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001683s ]