SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53354 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53354 [ RunTime:0.001819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (847124,869901,328846,894203,725787,55827,801365,215135,337235,53438,101781,362001,908255,261788,889939,459001,475718,369911,38608,491654,356690,196790,824913,577016,748848,111056,685540,110675,957379,642147,666286,232988,426391,109700,430069,571972,51291,949785,261008,537706,949455,797385,962287,584414,939831,332192,241276,234376,308346,188323,612488,817206,922630,338888,481266,212761,336646,751954,830840,1010397) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53354 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53354 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]