SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564272 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564272 [ RunTime:0.001496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (79146,617635,420630,769340,5671,106307,747588,485301,51450,121457,542801,733921,984720,232474,871715,212554,707179,904627,707588,870153,524137,609502,952889,670240,351658,512245,838319,30818,919738,1044478,276648,547663,1020418,805066,314067,194684,158415,1043526,880483,517924,336007,2360,167931,253793,354480,889428,683178,416302,702723,663925,488179,109900,1009011,868538,382090,678067,211608,1004300,851745,815147) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564272 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564272 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]