SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 145663 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 145663 [ RunTime:0.002890s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583495,1001307,265743,1031483,677606,526687,133451,1046524,224514,687758,962756,1030522,142005,483746,132470,196066,245409,920695,221408,949091,963766,274055,455830,529205,750715,853162,1042985,1023316,95583,265014,180814,687076,557983,195589,167537,357155,77781,1041752,45773,215323,231292,365612,715805,543667,101843,879805,538881,673980,705275,137518,197895,476809,716813,334061,294400,537627,375388,282269,464352,253238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 145663 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 145663 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]