SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319996 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319996 [ RunTime:0.001650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308134,417166,623286,678486,910826,403266,340379,557692,411711,943038,229868,826821,472880,915005,902585,245360,980110,492878,615056,807454,410408,803210,987033,276053,679911,417526,711202,593699,212531,259152,797217,143985,699299,402230,670311,309270,690567,173556,371133,386785,251212,692056,842451,141771,389646,303713,52195,373155,812271,735348,819433,621885,307309,755203,776121,219384,317222,261585,674327,228569) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319996 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000716s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319996 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001602s ]