SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419414 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419414 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (171671,698049,905379,897741,1006559,466355,586117,479532,384035,902391,124530,775210,841486,16150,838476,415691,913550,585433,21996,873574,389860,849800,172449,932455,655145,619029,919327,987933,832853,1003835,214987,372891,1029541,326487,457691,343103,23178,792693,965044,965928,166334,821868,34642,200052,908402,584401,123961,581566,1031484,520650,812429,682878,827080,499779,41399,463723,960513,222602,841256,169897) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000716s ]