SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545310 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545310 [ RunTime:0.001977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509874,295625,898133,737518,373436,796598,38586,922278,300726,726378,697540,936970,1020407,486323,797496,554904,581161,528499,754555,809035,628518,123953,289000,45814,202448,558395,195133,77035,828611,21259,4924,736584,980807,877172,913354,890490,371380,63070,50306,814039,546245,890438,928553,585671,1032371,954835,93637,775649,78063,382670,286507,46973,639122,214753,1022469,755219,128145,575666,659041,796595) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000393s ]