SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 959222 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 959222 [ RunTime:0.001769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415390,401542,868199,1028663,731287,1011084,667197,686349,69793,275791,280152,890716,611681,342141,539488,648236,1047218,550992,764736,148617,357665,217450,838493,128398,546393,521545,986180,484567,657524,741226,876352,7789,861169,735400,641600,116651,520223,846818,816043,226124,964884,717531,665999,345779,124756,88708,790926,473808,397860,318927,22947,274450,767313,584259,64973,295670,21641,22486,411731,873066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 959222 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 959222 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]