SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502043 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502043 [ RunTime:0.001458s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (178819,235935,197378,720713,418409,769439,372910,895822,671983,811785,785021,818947,966962,318822,875319,21701,743363,855841,843849,126539,550631,111298,590939,672725,1012845,76208,631444,928015,917220,191609,761713,414017,115396,869855,418624,207511,482108,403813,789759,471655,503684,414358,93179,841581,892046,871518,368353,534294,998722,71106,439551,297055,427845,662022,946927,475564,73371,710772,17744,402520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]