SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042512 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042512 [ RunTime:0.002772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447698,509363,685627,650406,1000283,581085,153729,66885,430669,283651,845166,771733,694838,246817,853798,259594,445424,449586,450770,662200,648086,757259,950933,381263,19639,447025,348450,809284,482121,327954,913821,812035,318430,820480,119967,822538,422440,363044,411356,141175,7756,54035,501615,974807,387878,118625,253774,611483,138659,435258,471217,631778,263966,398659,581075,129579,595578,614278,880008,33589) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000767s ]