SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 390517 LIMIT 1 [ RunTime:0.002300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 390517 [ RunTime:0.001582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013034,560290,593043,569600,838918,853995,400973,103782,454403,438738,681363,741234,1006246,893482,70035,36926,1011674,793696,225636,920926,28879,873463,843530,599633,750701,50134,105678,422112,187936,637214,730653,327623,69774,609147,846529,501289,360394,369488,665784,98310,455558,245297,603759,533082,580478,711355,1020358,395983,454339,1016221,612368,176499,886571,645388,879994,137153,749786,117682,750927,881030) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001876s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 390517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 390517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001344s ]